Previous Topic

Next Topic

International Address Formatting in iMIS Reports

International address formatting requires reports in all modules to
use the FULL_ADDRESS, Name.FULL_ADDRESS, Name_Address.FULL_ADDRESS, Orders.FULL_ADDRESS, or Order_Badge.FULL_ADDRESS fields rather than a concatenation of the individual address fields.

These fields are calculated based upon the address format associated
with the Country name in the Name Address record. Whenever FULL_ADDRESS is calculated, it is built based upon the appropriate address format.

If international address formatting is set up, these FULL_ADDRESS fields are calculated based upon the address format associated with the Country name on the Name Address record. When a new record is inserted into the database, a new ASI stored procedure called sp_asi_AddressUpdate calculates all FULL_ADDRESS values based upon the country specific address formats.

To update the FULL_ADDRESS fields for existing records in the database, you will need to execute the 'Run AddressUpdate' script (select Utilities>Reports and Queries>Table Maintenance). This script calls the ASI AddressUpdate stored procedure that recalculates the FULL_ADDRESS fields based upon the appropriate address format.

If you have to run the 'Rebuild Name_Address Pointers' script for any reason, please note that you will also need to run the 'Run AddressUpdate' script in order to rebuild FULL_ADDRESS based upon the international address formats.

See Also

Using International Address Formatting

Set up country names window

Address Layouts

Set up country address layouts window

To enter an address format

To apply an address format to a country

To test an address format

To view the address format applied to a country

To remove address formatting from a country

To edit an address format

To delete an address format


ASI logo 10.6 Production Release. Updated 1/18/2006 11:51:30 AM
© Copyright by Advanced Solutions International, Inc. All rights reserved.